Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MySQL
1) Aggregate Functions
2) Backup Load
3) Command Mysql
4) Cursor
5) Data Type
6) Database
7) Date Time
8) Engine
9) Event
10) Flow Control
11) Fulltext Search
12) Function
13) Geometric
14) Insert Delete Update
15) Internationalization
16) Join
17) Key
18) Math
19) Procedure Function
20) Regular Expression
21) Select Clause
22) String
23) Table Index
24) Transaction
25) Trigger
26) User Permission
27) View
28) Where Clause
29) XML

Key
1) A primary key on a column can be created by replacing PRIMARY KEY with UNIQUE in the table definition, provide
2) Add Foreign Key Rules
3) Add PRIMARY KEY or UNIQUE directly to the end of the column definition
4) Add the foreign key by using the following
5) Adding primary key for not null column
6) Alter table to Add an PRIMARY KEY
7) Another way to enforce uniqueness is to add a UNIQUE index rather than a PRIMARY KEY to a table
8) Cascade delete
9) Create a multiple-column primary key using UNIQUE, if the columns are declared NOT NULL
10) Create a primary key on the last_name and first_name columns using a PRIMARY KEY clause
11) Create a table t that contains an id column thats NOT NULL and declared as a primary key by means of a PRIMAR
12) Define and use primary key
13) Define foreign key
14) Defining Primary Keys
15) Drop primary key
16) If you were creating a primary key on more than one column, you would include both of those column names in th
17) On delete set null
18) Reference foreign key
19) RESTRICT update and delete
20) Setting a Primary Key 1
21) Setting a Primary Key 2
22) Setting a Primary Key 3
23) To drop an index that is not a PRIMARY KEY, you must specify the index name
24) Two foreign keys
25) Two ways to declare primary key when creating the table
26) Use a FOREIGN KEY constraint to define the foreign key
27) Use a PRIMARY KEY constraint
28) Using KEY modifier
29) Using three column as the primary key